﻿<?xml version="1.0" encoding="utf-8" ?>
<orm:MappingRoot MapDataStructure="Administration" TransactionType="ADONET" Namespace="Acom.AppOrganization" TransactionForRetrieve="false" RetrievePattern="Select_[Object]" SetSelectPattern="SelectAll_[Object]" CreatePattern="Insert_[Object]" UpdatePattern="Update_[Object]" DeletePattern="Delete_[Object]" Generate="CRUDS" CollectionType="Plural" xmlns:orm="http://kadgen.com/KADORM.xsd">
   <orm:SQLFunctionReplacement>
      <orm:SQLFunction Name="getdate" ReplaceWith="System.DateTime.Today" NETType="System.DateTime" />
   </orm:SQLFunctionReplacement>
   <orm:UniqueNamespaces />
   <orm:Build MapDataStructure="Administration" Name="ACom.AppOrganization" xmlns="" xmlns:kd="http://kadgen.com/Special.xsd">
      <orm:SPSet Name="StringValue" ObjectName="StringValue" TableName="StringValue" OriginalName="StringValue" Generate="CRUDS" NoGenStoredProc="false" Schema="dbo" IsChild="true" IsParent="false" IsMultiParentChild="false">
         <orm:RetrieveParameter Name="StringValueGuid" Column="StringValueGuid" Alias="StringValueGuid" UseForDesc="true" OriginalName="StringValueGuid" Caption="String Value" Ordinal="0" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
         <orm:WhereClause Clause="@StringValueGuid=[StringValue].[StringValueGuid]" />
         <orm:ForeignKeyTables>
            <orm:ForeignKeyTable Name="StringLogicalLocation">
               <orm:ForeignKey ChildColumn="StringLogicalLocationGuid" ChildTable="StringValue" ChildObject="StringValue" ChildProperty="StringLogicalLocationGuid" ParentColumn="StringLogicalLocationGuid" ParentTable="StringLogicalLocation" ParentObject="StringLogicalLocation" ParentProperty="StringLogicalLocationGuid" Ordinal="0" />
            </orm:ForeignKeyTable>
            <orm:ForeignKeyTable Name="Application">
               <orm:ForeignKey ChildColumn="ApplicationGuid" ChildTable="StringValue" ChildObject="StringValue" ChildProperty="ApplicationGuid" ParentColumn="ApplicationGuid" ParentTable="Application" ParentObject="Application" ParentProperty="ApplicationGuid" Ordinal="0" />
            </orm:ForeignKeyTable>
            <orm:ForeignKeyTable Name="Culture">
               <orm:ForeignKey ChildColumn="CultureGuid" ChildTable="StringValue" ChildObject="StringValue" ChildProperty="CultureGuid" ParentColumn="CultureGuid" ParentTable="Culture" ParentObject="Culture" ParentProperty="CultureGuid" Ordinal="0" />
            </orm:ForeignKeyTable>
            <orm:ForeignKeyTable Name="ResourceGenerationLocation">
               <orm:ForeignKey ChildColumn="StringLogicalLocationGuid" ChildTable="StringLogicalLocation" ChildObject="StringValue" ChildProperty="StringLogicalLocationGuid" ParentColumn="StringLogicalLocationGuid" ParentTable="StringLocation" ParentObject="ResourceGenerationLocation" ParentProperty="StringLogicalLocationGuid" Ordinal="0" />
               <orm:ForeignKey ChildColumn="StringLogicalLocationGuid" ChildTable="StringValue" ChildObject="StringValue" ChildProperty="StringLogicalLocationGuid" ParentColumn="StringLogicalLocationGuid" ParentTable="StringLogicalLocation" ParentObject="StringLogicalLocation" ParentProperty="StringLogicalLocationGuid" Ordinal="1" />
            </orm:ForeignKeyTable>
         </orm:ForeignKeyTables>
         <orm:SetSelect TableName="StringValue" Schema="dbo">
            <orm:SetSelectColumn Name="StringValueGuid" IsPrimaryKey="true" Column="StringValueGuid" TableName="StringValue" SQLType="uniqueidentifier" BaseNETType="System.Guid" NETType="System.Guid" IsAutoIncrement="false" />
            <orm:SetSelectColumn Name="StringLogicalLocationGuid" IsPrimaryKey="false" Column="StringLogicalLocationGuid" TableName="StringValue" SQLType="uniqueidentifier" BaseNETType="System.Guid" NETType="System.Guid" IsAutoIncrement="false" />
            <orm:SetSelectColumn Name="OriginalString" IsPrimaryKey="false" Column="OriginalString" TableName="StringValue" SQLType="nvarchar" BaseNETType="System.String" NETType="System.String" IsAutoIncrement="false" />
         </orm:SetSelect>
         <orm:BuildRecordset Name="RecSet" InsertPriority="1" ChildFlag="0" ChildName="">
            <orm:WhereClause Clause="@StringValueGuid=[StringValue].[StringValueGuid]" />
            <orm:Join Type="INNER" LeftTable="StringValue" RightTable="Culture" RightAlias="Culture" LeftOriginalName="StringValue" LeftAlias="StringValue" RightOriginalName="Culture" JoinStyle="In">
               <orm:JoinKey LeftColumn="CultureGuid" RightColumn="CultureGuid" SQLType="" IsAutoIncrement="false" LeafKeyIsPrimary="false" />
            </orm:Join>
            <orm:BuildTable Ordinal="0" TableName="StringValue" OriginalName="StringValue" Name="StringValue" JoinStyle="" RightAlias="StringValue" Schema="dbo">
               <orm:BuildColumn Name="StringValueGuid" Column="StringValueGuid" Alias="StringValueGuid" UseForDesc="true" OriginalName="StringValueGuid" Caption="String Value" Ordinal="1" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="StringLogicalLocationGuid" Column="StringLogicalLocationGuid" Alias="StringLogicalLocationGuid" UseForDesc="true" OriginalName="StringLogicalLocationGuid" Caption="String Logical Location" Ordinal="2" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="CultureGuid" Column="CultureGuid" Alias="CultureGuid" UseForDesc="false" OriginalName="CultureGuid" Caption="Culture" Ordinal="3" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="OriginalString" Column="OriginalString" Alias="OriginalString" UseForDesc="true" OriginalName="OriginalString" Caption="Original String" Ordinal="4" AllowNulls="false" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="OrganizationString" Column="OrganizationString" Alias="OrganizationString" UseForDesc="false" OriginalName="OrganizationString" Caption="Organization String" Ordinal="5" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="MachineTranslated" Column="MachineTranslated" Alias="MachineTranslated" UseForDesc="false" OriginalName="MachineTranslated" Caption="Machine Translated" Ordinal="6" AllowNulls="false" SQLType="bit" NETType="System.Boolean" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="ApplicationGuid" Column="ApplicationGuid" Alias="ApplicationGuid" UseForDesc="false" OriginalName="ApplicationGuid" Caption="Application" Ordinal="7" AllowNulls="true" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="TranslationSource" Column="TranslationSource" Alias="TranslationSource" UseForDesc="false" OriginalName="TranslationSource" Caption="Translation Source" Ordinal="8" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="TranslationDate" Column="TranslationDate" Alias="TranslationDate" UseForDesc="false" OriginalName="TranslationDate" Caption="Translation Date" Ordinal="9" AllowNulls="true" SQLType="datetime" NETType="System.DateTime" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="NeedsReview" Column="NeedsReview" Alias="NeedsReview" UseForDesc="false" OriginalName="NeedsReview" Caption="Needs Review" Ordinal="10" AllowNulls="true" SQLType="tinyint" NETType="System.Byte" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" MS_Description="0: No review, 1: Machine Translated, 2: Invariant value changed" />
            </orm:BuildTable>
            <orm:BuildTable Ordinal="0" TableName="Culture" OriginalName="Culture" Name="Culture" JoinStyle="In" RightAlias="Culture" Schema="dbo">
               <orm:BuildColumn Name="CultureGuid" Column="CultureGuid" Alias="CultureGuid" UseForDesc="false" OriginalName="CultureGuid" Caption="Culture" Ordinal="1" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="CultureId" Column="CultureId" Alias="CultureId" UseForDesc="false" OriginalName="CultureId" Caption="Culture Id" Ordinal="2" AllowNulls="false" SQLType="nvarchar" NETType="System.String" MaxLength="10" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="CultureName" Column="CultureName" Alias="CultureName" UseForDesc="false" OriginalName="CultureName" Caption="Culture Name" Ordinal="3" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="UnderlyingIdentifier" Column="UnderlyingIdentifier" Alias="UnderlyingIdentifier" UseForDesc="false" OriginalName="UnderlyingIdentifier" Caption="Underlying Identifier" Ordinal="4" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
               <orm:BuildColumn Name="Description" Column="Description" Alias="Description" UseForDesc="false" OriginalName="Description" Caption="Description" Ordinal="5" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" />
            </orm:BuildTable>
            <orm:TableColumn Name="StringValueGuid" TableName="StringValue" Column="StringValueGuid" Alias="StringValueGuid" UseForDesc="true" OriginalName="StringValueGuid" Caption="String Value" Ordinal="1" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" MaxLength="0" IsPrimaryKey="true" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="StringLogicalLocationGuid" TableName="StringValue" Column="StringLogicalLocationGuid" Alias="StringLogicalLocationGuid" UseForDesc="true" OriginalName="StringLogicalLocationGuid" Caption="String Logical Location" Ordinal="2" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="CultureGuid" TableName="StringValue" Column="CultureGuid" Alias="CultureGuid" UseForDesc="false" OriginalName="CultureGuid" Caption="Culture" Ordinal="3" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="OriginalString" TableName="StringValue" Column="OriginalString" Alias="OriginalString" UseForDesc="true" OriginalName="OriginalString" Caption="Original String" Ordinal="4" AllowNulls="false" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="OrganizationString" TableName="StringValue" Column="OrganizationString" Alias="OrganizationString" UseForDesc="false" OriginalName="OrganizationString" Caption="Organization String" Ordinal="5" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="MachineTranslated" TableName="StringValue" Column="MachineTranslated" Alias="MachineTranslated" UseForDesc="false" OriginalName="MachineTranslated" Caption="Machine Translated" Ordinal="6" AllowNulls="false" SQLType="bit" NETType="System.Boolean" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="ApplicationGuid" TableName="StringValue" Column="ApplicationGuid" Alias="ApplicationGuid" UseForDesc="false" OriginalName="ApplicationGuid" Caption="Application" Ordinal="7" AllowNulls="true" SQLType="uniqueidentifier" NETType="System.Guid" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="TranslationSource" TableName="StringValue" Column="TranslationSource" Alias="TranslationSource" UseForDesc="false" OriginalName="TranslationSource" Caption="Translation Source" Ordinal="8" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="TranslationDate" TableName="StringValue" Column="TranslationDate" Alias="TranslationDate" UseForDesc="false" OriginalName="TranslationDate" Caption="Translation Date" Ordinal="9" AllowNulls="true" SQLType="datetime" NETType="System.DateTime" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="NeedsReview" TableName="StringValue" Column="NeedsReview" Alias="NeedsReview" UseForDesc="false" OriginalName="NeedsReview" Caption="Needs Review" Ordinal="10" AllowNulls="true" SQLType="tinyint" NETType="System.Byte" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="StringValue" JoinBaseRootKey="false" JoinBaseLeafKey="false" MS_Description="0: No review, 1: Machine Translated, 2: Invariant value changed" />
            <orm:TableColumn Name="CultureGuid" TableName="Culture" Column="CultureGuid" Alias="Culture_CultureGuid" UseForDesc="false" OriginalName="CultureGuid" Caption="Culture" Ordinal="11" AllowNulls="false" SQLType="uniqueidentifier" NETType="System.Guid" MaxLength="0" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="Culture" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="CultureId" TableName="Culture" Column="CultureId" Alias="CultureId" UseForDesc="false" OriginalName="CultureId" Caption="Culture Id" Ordinal="12" AllowNulls="false" SQLType="nvarchar" NETType="System.String" MaxLength="10" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="Culture" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="CultureName" TableName="Culture" Column="CultureName" Alias="CultureName" UseForDesc="false" OriginalName="CultureName" Caption="Culture Name" Ordinal="13" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="Culture" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="UnderlyingIdentifier" TableName="Culture" Column="UnderlyingIdentifier" Alias="UnderlyingIdentifier" UseForDesc="false" OriginalName="UnderlyingIdentifier" Caption="Underlying Identifier" Ordinal="14" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="Culture" JoinBaseRootKey="false" JoinBaseLeafKey="false" />
            <orm:TableColumn Name="Description" TableName="Culture" Column="Description" Alias="Description" UseForDesc="false" OriginalName="Description" Caption="Description" Ordinal="15" AllowNulls="true" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" UDTCatalog="" UDTOwner="" UDTName="" IsAutoIncrement="false" IsComputed="false" Precision="0" Scale="0" Schema="dbo" TableAlias="Culture" JoinBaseRootKey="false" JoinBaseLeafKey="false" IsLocalizedProperty="true" />
         </orm:BuildRecordset>
         <orm:RunSP Name="Insert_StringValue" Task="Create">
            <orm:RunSPParam Name="StringValueGuid" Column="StringValueGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="StringLogicalLocationGuid" Column="StringLogicalLocationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="CultureGuid" Column="CultureGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="OriginalString" Column="OriginalString" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="OrganizationString" Column="OrganizationString" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="MachineTranslated" Column="MachineTranslated" Table="StringValue" OriginalTable="StringValue" SQLType="bit" NETType="System.Boolean" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="ApplicationGuid" Column="ApplicationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="TranslationSource" Column="TranslationSource" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="TranslationDate" Column="TranslationDate" Table="StringValue" OriginalTable="StringValue" SQLType="datetime" NETType="System.DateTime" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="NeedsReview" Column="NeedsReview" Table="StringValue" OriginalTable="StringValue" SQLType="tinyint" NETType="System.Byte" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
         </orm:RunSP>
         <orm:RunSP Name="Select_StringValue" Task="Retrieve">
            <orm:RunSPParam Name="StringValueGuid" Column="StringValueGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="Select_StringValue_By_OriginalString" Task="Retrieve" Alternate="true">
            <orm:RunSPParam Name="OriginalString" Column="OriginalString" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="SelectChildren_StringLogicalLocation_StringValue" Task="RetrieveChild" TempParentTableName="StringLogicalLocation" TempChildTableName="StringValue" ParentObjectName="StringLogicalLocation" ForeignKeyName="StringLogicalLocation">
            <orm:RunSPParam Name="StringLogicalLocationGuid" Column="StringLogicalLocationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="SelectChildren_Application_StringValue" Task="RetrieveChild" TempParentTableName="Application" TempChildTableName="StringValue" ParentObjectName="Application" ForeignKeyName="Application">
            <orm:RunSPParam Name="ApplicationGuid" Column="ApplicationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
         </orm:RunSP>
         <orm:RunSP Name="SelectChildren_Culture_StringValue" Task="RetrieveChild" TempParentTableName="Culture" TempChildTableName="StringValue" ParentObjectName="Culture" ForeignKeyName="Culture">
            <orm:RunSPParam Name="CultureGuid" Column="CultureGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="SelectChildren_ResourceGenerationLocation_StringValue" Task="RetrieveChild" TempParentTableName="ResourceGenerationLocation" TempChildTableName="StringValue" ParentObjectName="ResourceGenerationLocation" ForeignKeyName="ResourceGenerationLocation">
            <orm:RunSPParam Name="StringLogicalLocationGuid" Column="StringLogicalLocationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="StringLogicalLocationGuid" Column="StringLogicalLocationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="Update_StringValue" Task="Update">
            <orm:RunSPParam Name="StringValueGuid" Column="StringValueGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="StringLogicalLocationGuid" Column="StringLogicalLocationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="CultureGuid" Column="CultureGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="OriginalString" Column="OriginalString" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="OrganizationString" Column="OrganizationString" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="MachineTranslated" Column="MachineTranslated" Table="StringValue" OriginalTable="StringValue" SQLType="bit" NETType="System.Boolean" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
            <orm:RunSPParam Name="ApplicationGuid" Column="ApplicationGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="TranslationSource" Column="TranslationSource" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="50" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="TranslationDate" Column="TranslationDate" Table="StringValue" OriginalTable="StringValue" SQLType="datetime" NETType="System.DateTime" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
            <orm:RunSPParam Name="NeedsReview" Column="NeedsReview" Table="StringValue" OriginalTable="StringValue" SQLType="tinyint" NETType="System.Byte" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="true" />
         </orm:RunSP>
         <orm:RunSP Name="Delete_StringValue" Task="Delete">
            <orm:RunSPParam Name="StringValueGuid" Column="StringValueGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="true" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="SelectAll_StringValue" Task="SetSelect" />
         <orm:RunSP Name="SelectAll_StringValue_By_OriginalString" Task="SetSelect" Alternate="true">
            <orm:RunSPParam Name="OriginalString" Column="OriginalString" Table="StringValue" OriginalTable="StringValue" SQLType="nvarchar" NETType="System.String" MaxLength="500" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
         <orm:RunSP Name="SelectAll_StringValue_By_CultureGuid" Task="SetSelect" Alternate="true">
            <orm:RunSPParam Name="CultureGuid" Column="CultureGuid" Table="StringValue" OriginalTable="StringValue" SQLType="uniqueidentifier" NETType="System.Guid" IsPrimaryKey="false" IsAutoIncrement="false" AllowNulls="false" />
         </orm:RunSP>
      </orm:SPSet>

   </orm:Build>
</orm:MappingRoot>